How to know? Which version of PostgreSQL am I running?

Question

Aryan Kumar · Answer

Sure, there are a few ways to know which version of PostgreSQL you are running.
Using the psql command
One way to check the version of PostgreSQL you are running is to use the 
psql command. The psql command is a command-line tool that can be used to interact with a PostgreSQL database.
To check the version of PostgreSQL you are running, open a command prompt and run the following command:
psql -V
This will display the version of PostgreSQL that you are running.
Using the pg_version function
Another way to check the version of PostgreSQL you are running is to use the 
pg_version function. The pg_version function is a function that returns the version of PostgreSQL that is running.
To check the version of PostgreSQL you are running, open a PostgreSQL session and run the following command:
SELECT pg_version();
This will return the version of PostgreSQL that you are running.
Using the pgAdmin tool
If you are using the pgAdmin tool, you can check the version of PostgreSQL you are running by opening the pgAdmin tool and expanding the
Servers tree.
In the Servers tree, right-click the server that you want to check the version for and select
Properties. In the Properties dialog box, the version of PostgreSQL that you are running will be displayed in the
Version property.

forum

How to know? Which version of PostgreSQL am I running?

Utpal Vishwas

Can you answer this question?

1 Answers

Liked By